<html>
<body>
<form name ="p1" action="d12.php" method="get">
 

<select id="color">
<?php
$link = mysql_connect('localhost:3306', 'root', '');
$db_selected = mysql_select_db('shapes_colors', $link);
if (!$db_selected) {
    die ('Can\'t use shapes-colors : ' . mysql_error());
}

$sql = 'select row_colors from colors;';
$result = mysql_query($sql, $link);
while ($row = mysql_fetch_assoc($result)) {
    echo '<option>'. $row['row_colors'].'</option>';
 
}
echo '</select>';

echo '<select id="shape">';


$sql = 'select row_shapes from shapes;';
$result = mysql_query($sql, $link);
while ($row = mysql_fetch_assoc($result)) {
    echo '<option>'. $row['row_shapes'].'</option>';
 
}

?>
</select><button type="submit"></form>

<form name="p2" action="db4.php" method="get">
<p>enter color (e.x. yellow, green, blue)<input type="text" name="coltxt" value="" size="30" maxlength="10">
<p>enter shape (e.x. square, circle, triangle)<input type="text" name="shapetxt" value="" size="30" maxlength="10">
<button type="submit">

</form>
</body>
</html>

